dil_bert Posted July 13, 2017 Share Posted July 13, 2017 (edited) in Calc- i nave to cut the leading number and put it into a own colum - is this doable see the data Matthew 2:1 Jésus étant né à Bethléhem en Judée, au temps du roi Hérode, voici des mages d 'Orient arrivèrent à Jérusalem, 2 et dirent: Où est le roi des Juifs qui vient de naître ? car nous avons vu son étoile en Orient, et nous sommes venus pour l 'adorer. 3 Le roi Hérode, ayant appris cela, fut troublé, et tout Jérusalem avec lui. 4 Il assembla tous les principaux sacrificateurs et les scribes du peuple, et il s'informa auprès d'eux où devait naître le Christ. 5 Ils lui dirent: À Bethléhem en Judée; car voici ce qui a été écrit par le prophète: 6 Et toi, Bethléhem, terre de Juda, Tu n'es certes pas la moindre entre les principales villes de Juda, Car de toi sortira un chef Qui paîtra Israël, mon peuple. 7 Alors Hérode fit appeler en secret les mages, et s'enquit soigneusement auprès d'eux depuis combien de temps l'étoile brillait. 8 Puis il les envoya à Bethléhem, en disant: Allez, et prenez des informations exactes sur le petit enfant; quand vous l'aurez trouvé, faites-le-moi savoir, afin que j'aille aussi moi-même l'adorer. 9 Après avoir entendu le roi, ils partirent. Et voici, l'étoile qu 'ils avaient vue en Orient marchait devant eux jusqu'à ce qu'étant arrivée au-dessus du lieu où était le petit enfant, elle s'arrêta. 10 Quand ils aperçurent l'étoile, ils furent saisis d'une très grande joie. in Calc- i nave to cut the leading number and put it into a own colum - is this doable note - i have several thousand lines love to hear from you Edited July 13, 2017 by dil_bert Quote Link to comment https://forums.phpfreaks.com/topic/304313-in-calc-i-nave-to-cut-the-leading-number-and-put-it-into-a-own-colum-is-this-doable/ Share on other sites More sharing options...
requinix Posted July 13, 2017 Share Posted July 13, 2017 What? Calc? Quote Link to comment https://forums.phpfreaks.com/topic/304313-in-calc-i-nave-to-cut-the-leading-number-and-put-it-into-a-own-colum-is-this-doable/#findComment-1548284 Share on other sites More sharing options...
kicken Posted July 15, 2017 Share Posted July 15, 2017 Calc? I'm assuming they are refering to Openoffice / Libreoffice's version of Excel. in Calc- i nave to cut the leading number and put it into a own colum - is this doable Not with just Calc as far as I know. If you can pre-process it in another editor first to introduce a separator between the numbers and verses such as a tab then you could import it as a tab (or whatever) separated text document. For example, if you use an editor with regex replacement support you could do a find and replace along the lines of: Find: ^ *([0-9:]+) * Replace: \1\t To tab-separate the data then import it into Calc as a tab-delimited document. Quote Link to comment https://forums.phpfreaks.com/topic/304313-in-calc-i-nave-to-cut-the-leading-number-and-put-it-into-a-own-colum-is-this-doable/#findComment-1548354 Share on other sites More sharing options...
dil_bert Posted July 15, 2017 Author Share Posted July 15, 2017 hello _ many thanks i will try this out Quote Link to comment https://forums.phpfreaks.com/topic/304313-in-calc-i-nave-to-cut-the-leading-number-and-put-it-into-a-own-colum-is-this-doable/#findComment-1548368 Share on other sites More sharing options...
dil_bert Posted July 15, 2017 Author Share Posted July 15, 2017 hello again - i get - no matches found.... Quote Link to comment https://forums.phpfreaks.com/topic/304313-in-calc-i-nave-to-cut-the-leading-number-and-put-it-into-a-own-colum-is-this-doable/#findComment-1548369 Share on other sites More sharing options...
requinix Posted July 15, 2017 Share Posted July 15, 2017 And what about your other thread? It's annoying seeing the same question in two different places with two different people giving two different answers. Quote Link to comment https://forums.phpfreaks.com/topic/304313-in-calc-i-nave-to-cut-the-leading-number-and-put-it-into-a-own-colum-is-this-doable/#findComment-1548370 Share on other sites More sharing options...
dil_bert Posted July 15, 2017 Author Share Posted July 15, 2017 many many thanks - and a big big sorry i was in such a big hurrry the last days so i totally lost the overview. many thanks for all your help. have agreat day Quote Link to comment https://forums.phpfreaks.com/topic/304313-in-calc-i-nave-to-cut-the-leading-number-and-put-it-into-a-own-colum-is-this-doable/#findComment-1548384 Share on other sites More sharing options...
conoroco Posted July 18, 2017 Share Posted July 18, 2017 Did you manage to do it in the end? What fixed it? Quote Link to comment https://forums.phpfreaks.com/topic/304313-in-calc-i-nave-to-cut-the-leading-number-and-put-it-into-a-own-colum-is-this-doable/#findComment-1548531 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.