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
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
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.
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
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
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
Log in to reply to this topic.