Forum Discussion

Maria Baker's avatar
Maria Baker
Copper Contributor
Jul 16, 2020
Solved

Need to convert a text file to Excel - not the typical comma delineated file

I have a text file that needs to be converted to Excel however the text is grouped in a fashion that Excel doesn't not convert into columns but exactly as it appears in the text file.  The text conte...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 21, 2020

    Maria Baker 

    IMHO, it's not necessary to change delimiters, in general it's not necessary to make any changes in your text file. For the delimiters you may use split only on left most delimiter, that won't affect the dates. 

     

    Variant of layout as TheAntony  suggested is in TextTransformTwo query attached.

Maria Baker's avatar
Maria Baker
Copper Contributor
Jul 21, 2020

TheAntony First thank you very much for the assistance.  My apologies for being so thick......how did you change the delimiter from : to ; in the text file? My original file has 38000 rows.

 

Best Regards

MB

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 21, 2020

Maria Baker 

IMHO, it's not necessary to change delimiters, in general it's not necessary to make any changes in your text file. For the delimiters you may use split only on left most delimiter, that won't affect the dates. 

 

Variant of layout as TheAntony  suggested is in TextTransformTwo query attached.

Resources