Importing data that is sperated by l,l and I cant get right

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Below is what I am trying to import but witn no susess
PS there is lots more, it seems the that sperator is " l ,l "

|Master
List|,||,|1219|,|1221|,|1220|,|1225|,|1219|,|328|,|849|,|343|,|2294|,|2650|,|2601|,|85|,|9815|,|12181|
|blank_____|,|Unhinged|,|Blue|,|Creature - Shapeshifter|,|1U|,|1/1|,|1: This
card's name becomes the name of your choice. Play this ability anywhere,
anytime.|,|1: This card's flavor text becomes the flavor text of your choice.
(This ability doesn't work because it's flavor text, not rules text (but
neither does this reminder text, so you figure it out).)#23|,|Ron
Spears|,|Uncommon|,0,11076
|1996 World Champion|,|Promotional|,|Multicolor|,|Creature -
Legend|,|WUBRG|,|*/*|,|Cannot be the targets of spells or effects. World
Champion has power and toughness equal to the life totals of target opponent.
0: Discard your hand to search your library for 1996 World Champion and
reveal it to all players. Shuffle your library and pu
 
Hi NCS,

It's a comma seperated file with the delimiter as a comma. The text qualifer
is the pipe " | " which is just above the Enter key on most keyboards. If it
has a | around it, it's treated as text and not a number. If using the import
wizard, you need to manually put this | as the text qualifier.

There is a problem starting with about the 28th field where the data looks
like:
,0,11076|1996 World Champion|,

The lack of a comma in 11076|1996 messes up the rest of the import.
Probably needs to look like:
,0,11076,|1996 World Champion|,

After putting in the comma, it imports very well as a text file with commas
for the delimiter and pipes for the text qualifier.
 
Back
Top