PoshCode Archive  Hex Artifact Content

Artifact 4b7d8322fd441f7d3295a13678d7824d14eb31f96cbb4fb23fc7083262374b05:


0000: 23 20 65 6e 63 6f 64 69 6e 67 3a 20 61 73 63 69  # encoding: asci
0010: 69 0d 0a 23 20 61 70 69 3a 20 70 6f 77 65 72 73  i..# api: powers
0020: 68 65 6c 6c 0d 0a 23 20 74 69 74 6c 65 3a 20 0d  hell..# title: .
0030: 0a 23 20 64 65 73 63 72 69 70 74 69 6f 6e 3a 20  .# description: 
0040: 55 73 65 20 6f 66 20 65 78 70 6f 72 74 2d 63 73  Use of export-cs
0050: 76 20 2d 41 70 70 65 6e 64 0d 0a 23 20 76 65 72  v -Append..# ver
0060: 73 69 6f 6e 3a 20 30 2e 31 0d 0a 23 20 74 79 70  sion: 0.1..# typ
0070: 65 3a 20 73 63 72 69 70 74 0d 0a 23 20 6c 69 63  e: script..# lic
0080: 65 6e 73 65 3a 20 43 43 30 0d 0a 23 20 78 2d 70  ense: CC0..# x-p
0090: 6f 73 68 63 6f 64 65 2d 69 64 3a 20 33 36 37 31  oshcode-id: 3671
00a0: 0d 0a 23 20 78 2d 61 72 63 68 69 76 65 64 3a 20  ..# x-archived: 
00b0: 32 30 31 32 2d 31 30 2d 32 31 54 31 36 3a 34 32  2012-10-21T16:42
00c0: 3a 30 33 0d 0a 23 0d 0a 23 0d 0a 48 69 2c 0d 0a  :03..#..#..Hi,..
00d0: 0d 0a 49 27 76 65 20 74 72 69 65 64 20 79 6f 75  ..I've tried you
00e0: 72 20 65 78 63 65 6c 6c 65 6e 74 20 2d 41 70 70  r excellent -App
00f0: 65 6e 64 20 66 65 61 74 75 72 65 20 66 6f 72 20  end feature for 
0100: 65 78 70 6f 72 74 2d 63 73 76 20 61 6e 64 20 69  export-csv and i
0110: 74 20 77 6f 72 6b 73 20 67 6f 6f 64 2e 20 49 27  t works good. I'
0120: 76 65 20 6f 6e 6c 79 20 68 61 76 65 20 61 20 73  ve only have a s
0130: 68 6f 72 74 20 71 75 65 73 74 69 6f 6e 2e 20 0d  hort question. .
0140: 0a 0d 0a 49 73 20 69 74 20 70 6f 73 73 69 62 6c  ...Is it possibl
0150: 65 20 74 6f 20 6d 61 6b 65 20 74 68 65 20 61 70  e to make the ap
0160: 70 65 6e 64 20 74 6f 20 6e 65 77 20 63 6f 6c 75  pend to new colu
0170: 6d 6e 73 20 69 6e 73 74 65 61 64 20 6f 66 20 72  mns instead of r
0180: 6f 77 73 3f 20 49 27 64 20 6c 69 6b 65 20 74 6f  ows? I'd like to
0190: 20 63 6f 6d 62 69 6e 65 20 74 77 6f 20 63 73 76   combine two csv
01a0: 20 66 69 6c 65 73 20 61 73 20 61 20 70 61 72 74   files as a part
01b0: 20 6f 66 20 61 6e 20 61 75 74 6f 6d 61 74 69 6f   of an automatio
01c0: 6e 20 73 63 72 69 70 74 20 61 6e 64 20 74 68 65  n script and the
01d0: 6e 20 49 20 6d 75 73 74 20 67 65 74 20 74 68 69  n I must get thi
01e0: 73 20 74 6f 20 77 6f 72 6b 2e 0d 0a 0d 0a 0d 0a  s to work.......
01f0: 49 6d 70 6f 72 74 2d 63 73 76 20 20 43 3a 5c 56  Import-csv  C:\V
0200: 69 73 69 6f 6c 69 7a 65 72 5c 43 49 2e 63 73 76  isiolizer\CI.csv
0210: 20 7c 20 53 65 6c 65 63 74 2d 4f 62 6a 65 63 74   | Select-Object
0220: 20 2a 20 7c 20 45 78 70 6f 72 74 2d 43 73 76 20   * | Export-Csv 
0230: 43 3a 5c 56 69 73 69 6f 6c 69 7a 65 72 5c 52 65  C:\Visiolizer\Re
0240: 6c 61 74 69 6f 6e 2e 63 73 76 20 2d 41 70 70 65  lation.csv -Appe
0250: 6e 64 0d 0a 0d 0a 54 68 65 20 61 62 6f 76 65 20  nd....The above 
0260: 77 6f 72 6b 20 77 69 74 68 20 79 6f 75 72 20 73  work with your s
0270: 6f 75 72 63 65 20 63 6f 64 65 20 69 6d 70 6f 72  ource code impor
0280: 74 65 64 20 74 6f 20 6d 79 20 24 70 72 6f 66 69  ted to my $profi
0290: 6c 65 2c 20 62 75 74 20 49 27 64 20 6c 69 6b 65  le, but I'd like
02a0: 20 74 6f 20 61 70 70 65 6e 64 20 69 74 20 74 6f   to append it to
02b0: 20 63 6f 6c 75 6d 6e 73 2e 20 44 6f 20 79 6f 75   columns. Do you
02c0: 20 6b 6e 6f 77 20 6f 66 20 61 6e 79 20 73 6f 6c   know of any sol
02d0: 75 74 69 6f 6e 3f 0d 0a 0d 0a 57 6f 75 6c 64 20  ution?....Would 
02e0: 62 65 20 76 65 72 79 20 74 68 61 6e 6b 66 75 6c  be very thankful
02f0: 20 66 6f 72 20 61 20 72 65 73 70 6f 6e 73 65 0d   for a response.
0300: 0a 0d 0a 52 65 67 61 72 64 73 0d 0a 45 72 69 6b  ...Regards..Erik
0310: 0d 0a                                            ..