I have a series of csv files that contain CHAR(29) spaces - I would like to use these as delimeters in PQ Combining into a Database. File attached has CHAR(29) in 2 places within Row-2. They are not visible unless you look iin the formula bar.
PQ imports without visibility of the CHAR(29) so cannot be used to split the column.
On export form PQ, the resultant table replicates the csv (visibilty in formla bar only)
Has anbody experienced this &/or can anyone advise on execution?
@dp
Not really sure what CHAR(29) is supposed to be doing but it shows as a small rectangle within the texts. I just copied the character and then pasted it as a custom character in the Splitting step.
This is what I saw next:
Thank you, Riny.
The data is machine output from a Carton Scanner - these delimiters are generated out of the Barcode.
If you copy the space from formula bar, then paste it to a blank cell, eg “A1”.
Run Cell(A1) tells you that it is CHAR(29)
I used your character in simple “Split Column” & got a positive result.
Kind Regards,
David