Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel pitanje

9 views
Skip to first unread message

Rajnus

unread,
Apr 1, 2014, 10:29:15 AM4/1/14
to
Napravio sam da mi se svaki mail koji dobijem dodaje u novi red u excel tablici.
Jedno od polja excela je body mail-a. Mene zanima jeli ikako moguce napraviti
da po nekom filteru samo jedna rijec iz te celije bude prikazana.

Konkretno: (mene zanima samo cijena karte koja je u ovom slucaju 161€)

Price Alerts | Price rise: Munich to Sofia   Price Alerts       We've found a new price for your saved alert       Checked on 23 Mar at 12:14 GMT     Remember that ticket prices can change rapidly. Click "Search now" to check live prices.               Munich (MUC) to Sofia (SOF)   Stop this alert       Fri, 10 Oct 2014 - Sun, 12 Oct 2014 | Economy           Best price, per person:         161 € ▲ 1 € since 20 Mar Search now           Search for Hotels in Sofia   Search for Car Hire in Sofia       The prices shown are the cheapest flights per person on our site and include an estimate of all mandatory taxes and charges. Skyscanner endeavours to ensure prices are up to date and accurate, however accuracy of price information is not guaranteed. To guarantee delivery of this email please add price...@mailer.skyscanner.net to your address book and safe senders list. Registered Office: Skyscanner Ltd, Pinsent Masons LLP, 5 Old Bailey, London EC4M 7BA, UK; UK Company Number: 04217916; VAT Registration Number: GB 774428503; Unsubscribe | Privacy and cookie policy | Contact us | www.skyscanner.net

b&s

unread,
Apr 1, 2014, 5:55:37 PM4/1/14
to
Rajnus wrote:
> Napravio sam da mi se svaki mail koji dobijem dodaje u novi red u
> excel tablici.
> Jedno od polja excela je body mail-a. Mene zanima jeli ikako moguce
> napraviti
> da po nekom filteru samo jedna rijec iz te celije bude prikazana.
>
> Konkretno: (mene zanima samo cijena karte koja je u ovom slucaju 161?)
>
> Price Alerts | Price rise: Munich to Sofia Price
> Alerts We've found a new
> price for your saved alert
> Checked on 23 Mar at 12:14 GMT
> Remember that ticket prices can change rapidly. Click "Search now" to
> check live prices. Munich (MUC) to
> Sofia (SOF) Stop this alert
> Fri, 10 Oct 2014 - Sun, 12 Oct 2014 |
> Economy Best
> price, per person: 161 ?
> ? 1 ? since 20 Mar
> Search now
> Search for Hotels in Sofia
> Search for Car Hire in Sofia The prices shown are
> the cheapest flights per person on our site and include an estimate
> of all mandatory taxes and charges. Skyscanner endeavours to ensure
> prices are up to date and accurate, however accuracy of price
> information is not guaranteed. To guarantee delivery of this email
> please add price...@mailer.skyscanner.net to your address book and
> safe senders list. Registered Office: Skyscanner Ltd,
> Pinsent Masons LLP, 5 Old Bailey, London EC4M 7BA, UK;
> UK Company Number: 04217916; VAT Registration Number: GB 774428503;
> Unsubscribe | Privacy and cookie policy | Contact us |
> www.skyscanner.net

... evo za probu: ako je 'body' u polju A1, onda u neko drugo polje gdje
želiš prikaz upiši ovo:
=TRIM(MID(A1;FIND("?";A1)-5;7))

--
pozdrav!
Berislav


b&s

unread,
Apr 1, 2014, 6:02:43 PM4/1/14
to
b&s wrote:
> ... evo za probu: ako je 'body' u polju A1, onda u neko drugo polje
> gdje ľelią prikaz upiąi ovo:
> =TRIM(MID(A1;FIND("?";A1)-5;7))

... ovaj upitnik mi je uvalio mail-reader; umjesto upitnika treba biti
oznaka za euro:""€""

--
pozdrav!
Berislav



Rajnus

unread,
Apr 2, 2014, 5:05:40 AM4/2/14
to
On Wednesday, 2 April 2014 00:02:43 UTC+2, b&s wrote:

> ... ovaj upitnik mi je uvalio mail-reader; umjesto upitnika treba biti
>
> oznaka za euro:""EURO""

sljaka, hvala :)

Rajnus

unread,
Apr 2, 2014, 6:47:22 AM4/2/14
to
On Wednesday, 2 April 2014 11:05:40 UTC+2, Rajnus wrote:

> sljaka, hvala :)

https://docs.google.com/spreadsheet/ccc?key=0AhED6mql0cdsdEczZk52Q2ZYYVc2QzNzYVNrRGpMTEE&usp=docslist_api#gid=0

b&s

unread,
Apr 2, 2014, 6:31:46 AM4/2/14
to
... drago mi je da sljaka ;-)

--
pozdrav!
Berislav


b&s

unread,
Apr 2, 2014, 7:14:48 AM4/2/14
to
... dokumentirao - da sljaka! :-)

--
pozdrav!
Berislav



Rajnus

unread,
Apr 2, 2014, 8:02:01 AM4/2/14
to
On Wednesday, 2 April 2014 13:14:48 UTC+2, b&s wrote:

> ... dokumentirao - da sljaka! :-)

Jep odlican tool za pracenje kretanje cijena letova ili hotela.

Evo i kako sam to napravio:

1. Na skyscanner za odredjenu rutu prijaviti mail (Gmail) na koji ce se slati promjene cijena.
2. Napraviti IFFT account i kreirati triger. Moj recipe https://ifttt.com/recipes/158319-gmail-to-excel
3. Otvoriti tablicu (Gdrive) i u E1 polje upisati ovo: =TRIM(MID(D1;FIND("EURO";D1)-5;7)) te razvuci po stupcu dolje

and voila :)

b&s

unread,
Apr 2, 2014, 9:21:46 AM4/2/14
to
... da se oslobodis greske upisi ovo: ;-)
=IFERROR(TRIM(MID(D1;(FIND("EURO";D1)-5);7));"")

--
pozdrav!
Berislav


Rajnus

unread,
Apr 2, 2014, 10:20:20 AM4/2/14
to
On Wednesday, 2 April 2014 15:21:46 UTC+2, b&s wrote:

> =IFERROR(TRIM(MID(D1;(FIND("EURO";D1)-5);7));"")

great :)

0 new messages