Forum Discussion

1001's avatar
1001
Icon for Resolver II rankResolver II
3 years ago
Solved

Delimiter | not working

Hi, I have a strange importing behaviour with a text file which I'm unsure how to resolve. On import, I see this table:     I then select 'Custom' from the Delimiter field and the sampl...
Need Help
  • 1001's avatar
    1001
    3 years ago

    Hi All, I found the solution. Upon importing of the file, only 1 column of data is visible when using '|' as the delimiter. This text file was originally an exported file from SAP. 

    To display the entire expanded data set with its original columns, you need to open the Advanced Editor where you'll see the display code as below (I've blanked out the file address).

     

    Within this code, look for 'Column1' (outlined in Red).

    Here, I simply changed the 1 to 21 as you can see, then the entire table expanded from one column to 21 columns, displaying all the original data from the source file.

    Cheers.    

1001's avatar
1001
Icon for Resolver II rankResolver II
3 years ago

Hi All, I found the solution. Upon importing of the file, only 1 column of data is visible when using '|' as the delimiter. This text file was originally an exported file from SAP. 

To display the entire expanded data set with its original columns, you need to open the Advanced Editor where you'll see the display code as below (I've blanked out the file address).

 

Within this code, look for 'Column1' (outlined in Red).

Here, I simply changed the 1 to 21 as you can see, then the entire table expanded from one column to 21 columns, displaying all the original data from the source file.

Cheers.