If we tick At the end, the result will be ab. If we tick At the beginning, we'll have ab |. If you want to preserve delimiters, check the Keep delimiters in resulting cells box and tick At the beginning or At the end.įor instance, if we have "ab.cd.ef" in a cell, split it by "." and do not check this box, we will get ab | cd | ef By default, delimiters that you enter are not placed into the split dataset.If the values you want to split are divided by several successive symbols, tick off the Treat consecutive delimiters as one checkbox.Also, you can enter any other character into the Custom field. The values you want to split may be separated by standard delimiters, such as comma, space, semicolon, and/or line break. The tool can split only one column at a time.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |