Parse multiple Tags upon import?

[SereneLandscape]

Is there a way to parse multiple Tags upon import of a CSV?

I have labeled my raw CSV rows with one to many tags per row. When I attempt importing multiple tags that are separated by a semicolon, MMEX interprets it as one string.

For example, my CSV looks like this:
Amount,Type,Category,SubCategory,Tags
-240.00,Withdrawal,Sports,Basketball,Amy;Brian

I want "Amy" to come in as a tag, and "Brian" to come in as a tag. MMEX is instead creating a new tag called "Amy;Brian".

[Renato]

Since the delimiter is a comma, Amy;Brian is considered a single value.
I don't know whether multiple tags can be imported, but you can try replacing the ; with a ,

[frankieorabona]

Is there a way to parse multiple Tags upon import of a CSV?

I have labeled my raw CSV rows with one to many tags per row. When I attempt importing multiple tags that are separated by a semicolon, MMEX interprets it as one string.

For example, my CSV looks like this:
Amount,Type,Category,SubCategory,Tags
-240.00,Withdrawal,Sports,Basketball,Amy;Brian

I want "Amy" to come in as a tag, and "Brian" to come in as a tag. MMEX is instead creating a new tag called "Amy;Brian".

Renato’s suggestion may actually cause some issues (and I hope he’ll forgive me for contradicting him ) .
Replacing

Code: Select all

 ;

with

Code: Select all

 ,

does not work when the comma is used as the CSV delimiter, because it would be interpreted as the start of a new column, potentially shifting or breaking the following data.

Replacing

Code: Select all

;

with a space, instead, avoids breaking the CSV import and allows MMEX to correctly interpret the values as multiple separate tags.
I have personally tested this solution and I am still using it successfully.

[SereneLandscape]

Fantastic - thank you for your replies.

I have successfully imported data with the tag values separated by spaces, and it came in perfectly.

MMEX is an impressive program. Thank you for the great help documentation and the "Using Tags in Reports" section. I look forward to grouping by tags to be available in official MMEX reports.