field name with space char ' '

[eladberko]

hi!

i need to store a table in .CSV, but some of the fields must start with space char ' '.

in the example i will need to replace all '#' with ' ', and store the table in csv format.

every time that i do that - QS remove the blanks automatically.

[export]:
LOAD * INLINE
[
#HEADER_1|#HEADER_2|HEADER_3|HEADER_4
#Field_1|Field_2|Field_3|Field_4
] (DELIMITER IS '|');

[Kushal_Chawda · Accepted solution]

@eladberko  try below

rename_fields:
mapping Load FieldFrom,
     Replace('['&FieldFrom&']','#',chr(160)) as FieldTo;
Load * Inline [
FieldFrom
#HEADER_1
#HEADER_2
#HEADER_3 ];

[export]:
LOAD * INLINE
[
#HEADER_1|#HEADER_2|#HEADER_3
] (DELIMITER IS '|');

Rename Fields using rename_fields;