1. drees
  2. RO CSVI
  3. Sunday, 21 July 2019
  4.  Subscribe via email
I want to process this tran0487. txt file with csvi. It is a text file without separators but with fixed positions. With the line Csvi multireplace and on option Substring, I can only select the first field. The next field goes to (,) and then the substring is processed. If I change the comma to 0 then the csvi does not recognize the file. Being so super if you know a solution. readme0487.txt tran0487.txt readme0487.txt tran0487.txt
Accepted Answer Pending Moderation
Hello Drees,
Visual basic for applications(VBA) is a programming language for Excel so it would have been possible to read your file with it.

Glad to know you found a way out.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
It takes some energy. But we succeeded through a vba in exel.


Workbooks.OpenText Filename:="C:\Users\Drees\Downloads\tran0487.txt", Origin _
:=xlMSDOS, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0 _
, 1), Array(3, 1), Array(17, 1), Array(32, 2), Array(45, 1), Array(59, 1), Array(91, 1), _
Array(92, 1), Array(112, 1), Array(119, 1), Array(123, 1), Array(125, 1), Array(131, 1), _
Array(132, 1), Array(134, 1), Array(137, 1), Array(151, 1), Array(163, 1), Array(175, 1), _
Array(151, 1), Array(163, 1), Array(175, 1), Array(181, 1), Array(187, 1), Array(191, 1), _
Array(197, 1), Array(199, 1), Array(201, 1)), TrailingMinusNumbers:=True

Range("E5";).Select
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Drees,
Check if there is a way to differentiate data for each row from that one line you have. That should be the next step to move forward.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
That's too bad. I'm going to try to make a scrip. I don't have much knowledge of php. But will try. Does anyone have any tips.? I already have a small piece but everything comes on 1 line.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Drees,
CSVI cannot process files with fixed positions. That could be a reason that multi replace plugin is reading only the first field.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!