import data with the delimiter |

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

bonnuck
Posts: 3
Joined: Wed Mar 12, 2014 7:56 am

import data with the delimiter |

Postby bonnuck » Thu Mar 13, 2014 7:10 am

Dear Sir/Madam,

which is the command for import data from a file.csv that has the character | as delimeter? If I import the data manually, from file-import-import from file, I have no problem, but if I try from a program it doesn't work.

For example:

import(custom=|) c:\test.csv @freq u 1

eviews doesn't consider the delimiter.

thanks

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13323
Joined: Tue Sep 16, 2008 5:38 pm

Re: import data with the delimiter |

Postby EViews Gareth » Thu Mar 13, 2014 8:11 am

Probably:

Code: Select all

import c:\test.csv custom="|" @freq u 1
Follow us on Twitter @IHSEViews

bonnuck
Posts: 3
Joined: Wed Mar 12, 2014 7:56 am

Re: import data with the delimiter |

Postby bonnuck » Thu Mar 13, 2014 8:21 am

Yes, also without quotes --> import c:\test.csv custom="|" @freq u 1
thanks a lot

fmramos
Posts: 113
Joined: Fri Sep 19, 2008 7:30 am
Location: Sao Paulo / Brazil
Contact:

Re: import data with the delimiter |

Postby fmramos » Wed Feb 28, 2024 11:54 am

Hey there! And what if I have two different 'custom' delimiters: "T" (yes, the letter "T"), and ":"? HTML/JSON files...

Tks for any help. Best, Fabio

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13323
Joined: Tue Sep 16, 2008 5:38 pm

Re: import data with the delimiter |

Postby EViews Gareth » Wed Feb 28, 2024 12:09 pm

I think you're out of luck.
Follow us on Twitter @IHSEViews

fmramos
Posts: 113
Joined: Fri Sep 19, 2008 7:30 am
Location: Sao Paulo / Brazil
Contact:

Re: import data with the delimiter |

Postby fmramos » Wed Feb 28, 2024 12:41 pm

Np, lol


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 15 guests