Multi-record value, but only in the first line

[mrmut]

Hello people! This is my first post!

I came here, hoping for some help with FM import.

I have a CSV file that has a series of multi record values, but written only in the first line:

(Mr - multi record, SR - single record)

MR1 ; MR2 ; MR3 ; SR1.1 ; SR1.2

; ; ; SR2.1 ; SR2.2

; ; ; SR3.1 ; SR3.2

; ; ; SR4.1 ; SR4.2

The problem I have is with import - I would like the import this file in a way that all the lines have the same MR1, MR2 and MR3 values, with their own, unique values.

Thanks a lot!

[doughemi]

After importing, run a script:

Go to Record[first]

Set Variable[$mr1; Value:MyTable::MR1]

Set Variable[$mr2; Value:MyTable::MR2]

Set Variable[$mr3; Value:MyTable::MR3]

Replace Field Contents[No Dialog; MyTable::MR1; $mr1]

Replace Field Contents[No Dialog; MyTable::MR2; $mr2]

Replace Field Contents[No Dialog; MyTable::MR3; $mr3]

If you script the import, these lines could be in the same script, after the import step.

Import Records automatically makes the imported data the found set. Make sure you do not do anything between importing the data and these script steps that would cause the found set to change.

[mrmut]

In the meantime I've made an AutoIt script that, using a Notepad++, converts the output into a valid file. I will try to see if this would be the better (faster/simpler) way of doing it.

!

Thanks a lot! :-)

After importing, run a script:

Go to Record[first]

Set Variable[$mr1; Value:MyTable::MR1]

Set Variable[$mr2; Value:MyTable::MR2]

Set Variable[$mr3; Value:MyTable::MR3]

Replace Field Contents[No Dialog; MyTable::MR1; $mr1]

Replace Field Contents[No Dialog; MyTable::MR2; $mr2]

Replace Field Contents[No Dialog; MyTable::MR3; $mr3]

If you script the import, these lines could be in the same script, after the import step.

Import Records automatically makes the imported data the found set. Make sure you do not do anything between importing the data and these script steps that would cause the found set to change.