Please Share your Product Ideas with us!
All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.
All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.
There is a parameter in ADM for selecting the delimiter used in Transform text reports:
Console > Advance data migration> Advanced Configuration > Parameters > Report Settings > Report Column Delimiter.
The choices aren't great: A comma, a semicolon, a weird ƒ (one has to type alt + 1 5 9 or alt + 0 1 3 1 to generate this character from the keyboard), or a tilde character (a ~). The tilde character works best out of all these choices as this is a rather unusual character in text and is easy to type from the keyboard (a necessity for Excel). The comma and the semicolon are not good choices, as these characters are far too common in regular text to be used as a delimiter.
Since this is a drop down list, I would have expected a choice of a tab character as well as a vertical bar (a |). SAP uses a vertical bar for unconverted text and is also easy to type in Excel. A tab character is what Excel expects in a TXT file and can be selected via a menu in the Excel text import function (so no problem in designating the tab character as one's delimiter, at least from Excel's point of view).
Can the Tab character and the vertical bar be added to the delimiter options?
Attachments Open full size